package com.lrm.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import java.util.Set;

import com.lrm.db.DBFactory;

public class DriverTest {
	public static void main(String[] args) {
		try {
			String sql = "select * from emp";
			List<Map<String, Object>> lsts = DBFactory.getDBDriverIntence().getResultListMap(sql);
			for (Map<String, Object> map : lsts) {
//				Set<String> keys = map.keySet();
//				for (String key : keys) {
//					System.out.print("    " + key + "--" + map.get(key));
//				}
				Collection<Object> c = map.values();
				for (Object o : c) {
					System.out.print(o + "      ");
				}
				System.out.println();
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}
